UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'L1fgFmF8Luce1WLNTFlATOal81D2/YtFNbCEM4W53T8='
WHERE
key_id = '58639a177f37ccb6cc6fc411acba52c409c5b30eb8e94fe03cdde7a8be63a293'
AND (
token = 'L1fgFmF8Luce1WLNTFlATOal81D2/YtFNbCEM4W53T8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)