UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MoQNL34BGMUySvfGd0//5vS0k4szqknX2PJt5x58w3g='
WHERE
key_id = '24c47c7d6067555631647b3b25106192ef017ad8a8a745ce19185322e3838a88'
AND (
token = 'MoQNL34BGMUySvfGd0//5vS0k4szqknX2PJt5x58w3g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)