UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5yz31MgIyrTBFpasQOaO9prIgeuB/gpFjifF44PDPpA='
WHERE
key_id = 'cadc2f2afd99899621d31d902c1dfee304433559e8e5541c40dd3f37c89324fb'
AND (
token = '5yz31MgIyrTBFpasQOaO9prIgeuB/gpFjifF44PDPpA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)