UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'g6WXxV7dinZD/UfGjH6p0mvNYPB6P1qL5veyXLt4bOU=' 
WHERE 
  key_id = '1591c6de7e3ee51ad082cbc70e8dc3770c99a1d1ad9fd5d47bae75e9659449dc' 
  AND (
    token = 'g6WXxV7dinZD/UfGjH6p0mvNYPB6P1qL5veyXLt4bOU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00028