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