UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'snO8oqiwNiWIV5gFVyRSXjgK9WP9zFlPXYpMCdUVbfw='
WHERE
key_id = '42a2119ce863364aa50e97c46636aa5f4fa920d19579bab9b7fa2b8510f993d1'
AND (
token = 'snO8oqiwNiWIV5gFVyRSXjgK9WP9zFlPXYpMCdUVbfw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)