UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/xWYb7a2GqHNmXOc6e5JBo6LduwqToo2QRMtxVAtNWw='
WHERE
key_id = 'c4d49634ee9a7602760ed970ab6857a8dde1eaf80eb64424cdf1cf2f7f3c2149'
AND (
token = '/xWYb7a2GqHNmXOc6e5JBo6LduwqToo2QRMtxVAtNWw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)