UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3CxxNs+5kWhDzoEo0FYBq3LqQ9YkCIOXW853LocTSMM='
WHERE
key_id = '7939b01def9090d02faee02d5be415dbd8fd28f6e7709bc47dda6cd03bdd1dc1'
AND (
token = '3CxxNs+5kWhDzoEo0FYBq3LqQ9YkCIOXW853LocTSMM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)