UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Vv6orT0bDajMMGmgSWu7Eg2hbxeLFnUPPsZpDP5baSw=' 
WHERE 
  key_id = '24bc07d4ff4b0b60c3cf2a0a4c19044756d474b042940e42766233d47cb28a8f' 
  AND (
    token = 'Vv6orT0bDajMMGmgSWu7Eg2hbxeLFnUPPsZpDP5baSw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00049