UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7BFSHfiibfvCanar02o5WO7ZDcrrR5i1H9+k10dMtvE='
WHERE
key_id = '588ac67dc9e85db28feccfa4fd56b3990287dac3c26745dc885645e270a50423'
AND (
token = '7BFSHfiibfvCanar02o5WO7ZDcrrR5i1H9+k10dMtvE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)