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