UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Zfe0QvYGZHay2A6qQeoFJgBAZKaDbUK2Y/yguQ/1cTo='
WHERE
key_id = '87b416d7dd8905fe907badaf12540662feeb26ff26c471340ae2322fd8f90b4d'
AND (
token = 'Zfe0QvYGZHay2A6qQeoFJgBAZKaDbUK2Y/yguQ/1cTo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)