UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wqhuXo7Zw6Mzq06sIxPnhCcYN194hLQbTTi6uMlF7zU='
WHERE
key_id = '0a580d79d08e18b5abf51a98a2160379f3dc9d3e808fc6ead6208c4c223d7cc4'
AND (
token = 'wqhuXo7Zw6Mzq06sIxPnhCcYN194hLQbTTi6uMlF7zU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)