UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pJiAHAwfLRe6du0645RD2OS1vpabTOYVqCRD7G6R/s8='
WHERE
key_id = '021b6274ee6b66e3780df5cd755cacddb820bbbd5524e6150c314041386e48f5'
AND (
token = 'pJiAHAwfLRe6du0645RD2OS1vpabTOYVqCRD7G6R/s8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)