UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6YIvnFxiY263AbSaZ8Y3mvjs9WDnfD7ZELq71ohoqM8='
WHERE
key_id = 'a611bbe724e8eb8013309a17148d6952caa4d744ddc388aa97dfa3c703badf40'
AND (
token = '6YIvnFxiY263AbSaZ8Y3mvjs9WDnfD7ZELq71ohoqM8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)