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