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