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