UPDATE cscart_aprillock_keys SET expiry_at = UNIX_TIMESTAMP(NOW()) + 30, token = 'hCwbUrHzdROpA309/VTwTpWSebvd4yrU1r4blk6DfYk=' WHERE key_id = 'a55e2ae0bfa87b4c182c31130deb55fcb972aa6b232083d35a47481c99849a83' AND (token = 'hCwbUrHzdROpA309/VTwTpWSebvd4yrU1r4blk6DfYk=' OR expiry_at <= UNIX_TIMESTAMP(NOW()))