UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2LXBFNjerZfCc0gr9csUHGAn1YDfb4xxUV6pNg3PN2M='
WHERE
key_id = '0e58881c391755ac785bbca3813d5a512e70f8ed34e7e0dbf67ee72339c1a1a0'
AND (
token = '2LXBFNjerZfCc0gr9csUHGAn1YDfb4xxUV6pNg3PN2M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)