UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kSftVYgcyUkhk8sVkit8/wWUDBvkkGmEZyAtMX73EOM='
WHERE
key_id = '4bfa327c9c5559057b1ee074f9f83f81d841bbeef19c40e326b5575b69023716'
AND (
token = 'kSftVYgcyUkhk8sVkit8/wWUDBvkkGmEZyAtMX73EOM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)