UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IOUjLZ3dnGERzc+RNPjbEHdx04xMPE9JKsGIgtG13aU='
WHERE
key_id = 'a1885317c4f76172e5bc71ffa983f53f2e2e71d7614da1201ba8e7f94c13ad6b'
AND (
token = 'IOUjLZ3dnGERzc+RNPjbEHdx04xMPE9JKsGIgtG13aU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)