UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Tw0bTHfgSCH9AGpYA8b4m4JoINIbQSDf/smAgRBBi+g='
WHERE
key_id = '38d3a9b2ed7bc2b505e7b6e6c9c9f29bcad3ce2d799c81b115d26647a521ea78'
AND (
token = 'Tw0bTHfgSCH9AGpYA8b4m4JoINIbQSDf/smAgRBBi+g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)