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