UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'fmkdH6IBF2JmRqvV0aXPbt5WRscvTe89e/V5GcB9NUw=' 
WHERE 
  key_id = '773219f9be899a7e50fc3df94a640d13617a8a51e01b78fa8d46d8156c63e6a3' 
  AND (
    token = 'fmkdH6IBF2JmRqvV0aXPbt5WRscvTe89e/V5GcB9NUw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034