UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Rx7l2F9sb+ogjv6NBlHuS1gqv4aD/jPIEbI6L/WiV7s=' 
WHERE 
  key_id = '73d0dd1fd2e32a0d40fcda8f49b048feaad6847e7a480d6dd77960bee9af3af0' 
  AND (
    token = 'Rx7l2F9sb+ogjv6NBlHuS1gqv4aD/jPIEbI6L/WiV7s=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00014