UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8SPCsAAlgUP5acGmFjhAZRIC7ZQxcE7SXkHY5Yc6x0M='
WHERE
key_id = 'b807b99380dc40f4d3543da7e807a6d3f004ffe300eb871b55a239cc4d8331c6'
AND (
token = '8SPCsAAlgUP5acGmFjhAZRIC7ZQxcE7SXkHY5Yc6x0M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)