UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Y9AOehqkjE6VWpK2jp1g6Gd+NLzAKtWL2080a7rwDu8=' 
WHERE 
  key_id = '2a13288e43305a6368bd45dd273dbe904bf013f31cd3a1fd325d087caa3dcd85' 
  AND (
    token = 'Y9AOehqkjE6VWpK2jp1g6Gd+NLzAKtWL2080a7rwDu8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00046