UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iSfC7Um8rzwg3hHm5eOK1Xt0q7uZAInnHorRO8dIk14='
WHERE
key_id = 'e582ee0c0c6236d6c971b920d278f81f8c39a288417f53f3a090d84a66685e5b'
AND (
token = 'iSfC7Um8rzwg3hHm5eOK1Xt0q7uZAInnHorRO8dIk14='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)