UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UgD8v3/uCLcFbbOMOd5FQLQpa6x2Rg68rP+Y1qGoHaE='
WHERE
key_id = '3d9c7a90161680dff4a29f9c3097f746ace1fd5e87176a59eda6a221e28e9ad3'
AND (
token = 'UgD8v3/uCLcFbbOMOd5FQLQpa6x2Rg68rP+Y1qGoHaE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)