UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rwIyEQaw/c7QIhJRi58I9cHPoQbMyZfIQSj1vDGD1gw='
WHERE
key_id = '9f7e50852057f63d0df0a3676c7d06ed1eae650889031cace5b4ebb0f86b39c7'
AND (
token = 'rwIyEQaw/c7QIhJRi58I9cHPoQbMyZfIQSj1vDGD1gw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)