UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nR+scldEvLMajRhBy0pzIJVK4yBXnGWDX809EHm+xME='
WHERE
key_id = '00c8f749b53f08e0419d1d9929c36608be14e4335619a09b096892f765ba5da5'
AND (
token = 'nR+scldEvLMajRhBy0pzIJVK4yBXnGWDX809EHm+xME='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)