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