UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r9uGAlDPYDXAKZL7XWGlk7OgyAG3tYWmlU2A1/0jxjc='
WHERE
key_id = '4970cf98345bb998d9100885ba864445541ef2e113261de98576973e5a0368c6'
AND (
token = 'r9uGAlDPYDXAKZL7XWGlk7OgyAG3tYWmlU2A1/0jxjc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)