UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HYq9qigc4S+OVif0OvH1CUfjy+U5TsWN8G69xAHQ1tw='
WHERE
key_id = 'e4fa6bcb1de8c7b5683cb898648bb144b5cf1aeefdc44f57d8f2604723affa5b'
AND (
token = 'HYq9qigc4S+OVif0OvH1CUfjy+U5TsWN8G69xAHQ1tw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)